package com.movie.demo.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.movie.demo.pojo.Arrange;
import com.movie.demo.pojo.vo.Arrangeinfo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ArrangeMapper extends BaseMapper<Arrange> {
    @Select("select a.id,b.chinese_name,c.cname,d.r_name,a.time,b.price,a.state,a.mid,a.cid,a.rid from arrange a,movie b,cinema c,room d where \n" +
            "a.mid=b.mid and a.cid=c.cid and a.rid=d.id")
    List<Arrangeinfo> selectArrangeList();
}
